MacWorld 1996 July

home *** CD-ROM | disk | FTP | other *** search

/ MacWorld 1996 July / Macworld (1996-07).dmg / System 7.5 Update 2.0 / FileMaker Pro 3.0 CD Extras / FileMaker Examples / Integrated Solution / Contacts (.txt) < prev next >

Wrap

FileMaker Pro Database | 1996-01-25 | 201.0 KB | 1,128 lines | [FMP3/FMP3]

HBAM2016AUG95 Pro 3.0 WVVVVWXYZ[\\]\\]]]^^^QQQRSTUVVWWWXWVVVVVWVVVVUUTSRQPPQRSUVWVVVVVVWVWYZZ[\\]\]\\]^]][YWVTTVWYYZYYXWWVVVVWXYZ[[\[ZZ[[\\\\[ZYYYZ[[[[ZYWWWVWWWXYYYZ[\\]^_____PPPQRTUWWYZZZYXWVVVWWWWVUTTRPONNOPSUVWVWVVVWXWXZZZ[\\]^^^^^_^][YXVUUVWXYYYXXWVUUTTUWXZ\\]]]]^^___^\\ZYYYZ[[[ZYXXXWWWXXXXXYZ\]^_````_PPPQRTUWXZ[[[ZXWVVVWWWWVUTSQONMMNPSUWXWWVVVWXXYZZZZ[\]^_____^][YXVUUVWXYYYXXWVUTTTUWXZ\]^^^^_````_]\ZYYYZ[[[ZZYYYXXXXXXXXYZ\]_`aaaa`PPPQRTUWXZ[[[ZXWVVVWWWWVUSSQONMMNQTVXYXWVVVWXXYZZYYZ[\^_ \]^__``````_TUUUTSSSTUVVVUUTTTTUUUUTTSSSTTUVWYZ[[ZYWUTTUUVWWWVVVVWXXYYYYYYYZZZZYYXWVUTTTTUVWYZ[]]^^^\[ZYYZZ[[ZYXVVVWXZ[]_`aa`^[YXXY[]^__________UVVUTSSSTUVVVUUTTTUUVUUTUTTTUVWXYZ[[[ZYWUTTVVWXXXWWWWXYXYYYXYXYZZZZYYWVUUTTUUVXY[\\^^^^^\[ZYYZYZZYYXVWWXYZ[]__``_][YXXY\]^__^^^^^^^_UVVUTSSSUUWWWVVUUUVVWVVUUTTUVWXYZZZ[ZYXWUUUWWYZZ[ZZZZZZZZYYXXXXYYYYXXWVUUUUVWXZ[\]^_^^^^\\[ZYZZZZYYXWXXYZ[\]]]]]\\ZYYYZ\]^_^]]]\]]^^UVVUTSSSUVWXXXWVVVWWWWWVVUUVWXYZZZZZYXWVUVVXXZ[\]\\\\\\[[ZYYYXXXXXYXWVUUUVVXYZ\]^^__^^^^]\[[ZZZZZYYYXYYZ[\\\\[[ZZZYYYZ[\]^^]\[[[\\]^VVVTTTTTWWYZZYXWWWXXXXXW HBAM3016AUG95@ administrator[ assistant] associateX buyer managerZ marketingX marketing administrator[ marketing associateX personnel\ personnel administrator\ promotions] promotions assistant] representative^ salesZ sales managerZ sales representative^ accessoriesX acmeX accessoriesX assoc[ corp] corporationY framery\ norrisY norris corporationY posters^ printco smith[ smith waterman assoc[ framery\ unlimited^ waterman[ west] corp] worldwide^ worldwide posters unlimited^ dennis jennifer jeremy julie pamela sonia davidson norriz smith winford 5905\ brunswick harvard courtZ eighth liberty 0X Cancelled 15X Cancelled Pro 3.0F! Pro 3.0M% Sunday Monday Tuesday Wednesday Thursday Friday Saturday January February March April August September October November December 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter darton blvd^ blvd^ brunswick\ courtZ darton^ eighth[ harvardZ libertyX west] carsonZ carson cityZ cheylan cityZ eugene foster[ foster city[ green\ green groton 12345 54321 12/5/95 ACTION ID BUSINESS TITLE CANCEL FIND REQUEST COMPANY NAME CONTACT ID CONTACT TYPE CREATED BY DATE CREATED DATE MODIFIED FIRST NAME GENERAL COMMENTS LAST NAME MODIFIED BY PERSONAL TITLE PRIORITY REFERRED BY SORT ORDER STATE STREET ADDRESS TOTAL PURCHASES TOTAL RECORDS ZIP CODE Date CreatedB Date ModifiedB Contact Entry Contact Entry Help Find Contact View as List Dialog - No Records found Select Customer Contact Entry 2 Dialog - No Records Local Reports Sort Order Contacts Phone Book Avery 5160 Avery 5162 #10 Envelope Contact EntryB Created byB Modified byB Contact IDB Business TitleB Company NameB Personal TitleB First NameB A Last NameB Street AddressB CityB StateB Zip CodeB Contact TypeB Referred byB PriorityB TempB A Action IDB Total PurchasesB General CommentsB Total RecordsB Sort OrderB Cancel Find RequestB 7W Last NameX Cancelled Contact Entry HelpB Address Information Main Entry Address Information Main Entry View as Reports Contact Title First Namer Last Name Address Cityy ZIP Code Busines Title Contact Data Entry Company Name Action Date Action Type Action Status Phone Number Location Action History Contact Status New Activity Hours General Comments Find ContactB Contact Data Entry Main Entry View as Reports Contact Invoice Address Information Title First Name Last Name Address ZIP Code Busines Title Company Name Phone Number Location Action History wwwwww wwwwww Action Contact Status wwwwww wwwwww Action Date Action Type Action Status New Activity Hours General Comments A0Click to open database files and set preferences A(Click to enter information for a contact t Click to see a list of th A=Click to see a list of the contacts that are currently found. pe Click to create a record A=Click to choose a predefined print-out such as mailing labels pe Click to `te a record A8Click to find a customer record in the Contacts database the current customer. Your AKClick to create a record in the Invoices database for the current customer Pne numbers a A3Use this button to perform a script that you define information such as priority, cont pe Click to AeClick to enter contact information such as priority, contact type, and creation or modification info. Pne numbers a @eded for any A>Click to see a list of actions taken with the current customer A`Click to create a new call, letter, or fax for the current customer in the Activity Log database or the current customer in t Click to return to data entry View as ListB Main Entry View as Reports Contact Title Firstw Address City~ State ZIP Code Busines Title Company Name Find a Contact Cancel Contact ID All Records Contact Data Entry Dialog - No Records foundB c.Contact Data Entry - Select a Customer to edit Main Entry View as Reports Contact First Names Last Namet Company Name Select CustomerB Main Entry View as Reports Contact Contact Data Entry No Contacts Found IUNo contacts were found. Would you like to find again or create a new contact record? Create New Contact Entry 2B c?Clicking on a customer will create an Invoice for that customer View as Contact First Names Last Namet Company Name Entry First Names Last Namet Company Name Entry Main Reports Dialog - No Records LocalB Address Information Main Entry View as Reports Address Information Main Entry View as Reports Contact Title First Namer Last Name Address Cityy ZIP Code Busines Title Contact Data Entry Company Name Priority Contact Type Referred By Total Purchases Action History Contact Status Modified by Created by Date Modified Date Created General Comments Phone Number Location Hours ReportsB Main Entry View as Reports Contact Contact Data Entry No Contacts Found IONo contacts were found. Would you like to Find Again or go back to Data Entry? Data Entry Sort OrderB Main View as Reports (_N^. Contact Reports Entry Reports Contacts Phone Book Avery 5160 Labels Avery 5162 Labels #10 Envelopes g4Creating reports is quite easy and requires 2 steps: 2. Select the report below. Find Contacts k-There are currently << ABBG>> Contacts found. nB1. Find the contacts that you would like to create a report with. Your Own Report Contacts Phone BookB darton blvd@ VDEFA Main Entry View as Reports Contact Contact Data Entry Sort Order Perform Cancel MEClick on the desired sort order then click Perform to run the report. Avery 5160B ABAJ>> << ABAK>> ABAG>> ABAH>> ABAL>> ABAM>>, << ABAN>> << ABAO>> Avery 5162B ABAJ>> << ABAK>> ABAG>> ABAH>> ABAL>> ABAM>>, << ABAN>> << ABAO>> Phone Bookq Printed //r Printed by << AFAAABAFABAB>> :AJ<< ABAK>>, << ABAJ>> ABAH>> ABAL>> ABAM>>, << ABAN>> << ABAO>> 333333 333333 Page ## 333333 333333 Page ## #10 EnvelopeB ABAJ>> << ABAK>> ABAG>> ABAH>> ABAL>> ABAM>>, << ABAN>> << ABAO>>C[<< AFAAABAFABAC>> AFAAABAFABAD>> AFAAABAFABAE>>, << AFAAABAFABAF>> << AFAAABAFABAG>> 5/14/95B 11/20/95C Michael St. LorantD Michael St. LorantE Marketing AssociateG ACME AccessoriesH DennisJ SmithK 88 Liberty St.L GrotonM 12345O TradeQ HighU One of our best contacts. 5/14/95B 11/20/95C Michael St. LorantD Michael St. LorantE BuyerG Norris CorporationH SoniaJ LongK 88 Liberty St.L GrotonM 12345O Bus.Q 5/14/95B 11/20/95C Michael St. LorantD Michael St. LorantE Sales ManagerG PrintCoH JenniferJ NorrizK 614 Harvard CourtL Carson CityM 54321Q MedU(Jennifer hasn t called in several weeks. 5/14/95B 11/20/95C Michael St. LorantD Michael St. LorantE Marketing AdministratorG Smith & Waterman Assoc.H Mrs.I JulieJ DavidsonK 839 Eighth Ave.L Foster CityM 12345O Pers.Q 5/14/95B 11/20/95C Michael St. LorantD Michael St. LorantE Personnel AdministratorG The FrameryH JohnJ WinfordK 5905 Brunswick Ave.L Green BayM 54321O TradeQ 5/14/95B 11/20/95C Michael St. Lorant Your Own Script Find Customer Find Customer from Contacts Find Customer from Reports Find Customer from Invoices Find All Customers Cancel Find Sort by Last Name Sort by First Name Sort by Company Name Sort by Zip Code Perform Sort Create New Invoice Dial Phone Go to Data Entry Go to Main Menu Go to Reports Menu Preview or Print Show Activity Detail Create New Activity Phone Book Report Avery 5160 Report Avery 5162 Report #10 Envelope #10 Envelope Envelope Go to Main Menu Michael St. LorantE Promotions AssistantG West End Corp.H PamelaJ 466 West Ave.L CheylanM 12345O TradeQ 5/14/95B 11/20/95C Michael St. LorantD Michael St. LorantE Sales RepresentativeG Worldwide Posters UnlimitedH JeremyJ SmithK 912 Darton Blvd.L EugeneM 54321O TradeQ HighU Our main supplier for posters. Helvetica Geneva Times Find Customer Cancel Find "Cancelled" Cancelled Sort by Last Name Sort by First Name Sort by Company Name Find Customer from Invoices ) = 0 Find Customer from Invoices Create New Invoice ) = 0 Dial Phone Cancel Specify Field Use Dialing Preferences Phone Number Field Value Number Go to Main Menu Show Activity Detail ) = 101 Create New Activity ) = 0 Go to Reports Menu Find Customer from Reports Perform Sort Cancel Please, select a Sort Order or click Cancel.C5 = "First Name" First Name = "Last Name" Last Name Sort by Zip Code Phone Book Report Avery 5160 Report Avery 5162 Report Go to Data Entry Find All Customers #10 Envelope Preview or Print = "Company Name" Company Name = "Zip Code" Zip Code = "Custom Sort Order" Custom Sort Order Your Own Script Create your own script and B attatch it to a button. Find Customer from Contacts = "Cancelled" Cancelled ) = 0 ) = 1 ) = 1 "Preview") PreviewGB9 "Print") PrintG wwwwww ffffff UUUUUU DDDDDD 333333 wwwwww ffffff UUUUUU DDDDDD 333333 wwffeffg@ veUEDDCC vUTDD44 vUDDC32 #""# weUDD3 veTDC2233#3#2 wUDDC3##" vUTD3#22 vUDDC fUD42233##3#"! vTDCC##" eUDC3223## fTD4C3##23#"" uTDC3323#2""! 22"2" ##2"! fTDD33#22"" vUDC32"2"" WUTC22 eTD3#"" GDC32"!! eD3#"! T32"" #4EWp "4EVx #3EVg "4DUg #3EVg "#4DVg 24EVgy "34EVw ##4Efw ""3DUgw ""33DUfw ""34DVgx ""#34EVgx "#33DEfw " 234DUfw 2""2334DEVgx 3 4DEUfwx 3 DDUVgw D EUUfwx UDDEUUfgw U Vfgwx eUVfgww wwwwww ffffff UUUUUU DDDDDD 333333 """""" #11#22122"3! "#""3"129 wwwwww ffffff UUUUUU DDDDDD 333333 """""" wwxwwxw ggvgvv gvwxgwghg vhgvvww fvfgfwffv eVefefe VvffVefVVefUe\ ffFdeefeefddfDeVd fEdfFdffk EUeFFEUFEUFFUeTeVFeUUdVEEk UTdUTeETeETeEUFTUTUFTUUTeK TEETEETUETUETUDUDEETUDTUE[ 4CDD4E4ET DDCD4DD4CDDC C3C3C34C4C3CC43C "#""3"129 #11#22122"3! AD@D@ AD@D@ C3C3C34C4C3CC43C DDCD4DD4CDDC 4CDD4E4ET TEETEETUETUETUDUDEETUDTUE[ UTdUTeETeETeEUFTUTUFTUUTeK EUeFFEUFEUFFUeTeVFeUUdVEEk ffFdeefeefddfDeVdfEdfFdffk eVefefe VvffVefVVefUe\ fvfgfwffv ggvgvv gvwxgwghg vhgvvww wwxwwxw B"#B@ B"#B"$ 4"2$B"#B"#C 2$""#B"#C0 4"2#B"#C0 2$B"#C0 4""#C0 wwwwww ffffff 333333 """""" JJJJ !BBBB "99BB #9999 $9911 %1111 &)))) '!!!! DDDDDD wwwwww DDDDDD 333333 %US31 %US30 *00**- *00-00 00*0) 00*&0# ## !0*!%00+#!*0##-0'"0*#%00.! @@BA@ B220 DDDDDD B"#B0 B"#B"$ "2#B"#B"#@ 2$""#B"#@ "2#B"#@ 2$B"#@ DDDDDD DDDDDD UUUUUU wwwwww (*)(%,3& )%+@6) ",30,)% #*>A6332+$"! 25,878 #&$690*" !)0,++)( "%/66435/'# +3;4*= !#,@9,)+,(""(-/,,* !$&(265389,#!$$ '275? " $$*23/$ $),-..)'' !$&)(-5439@1!!&*-3/)!!%6B) )220(!$*.,,.' !$&*,*023:?B+*.,/3254.' "++,3/(.584.," !#&+/-./3:9@G@60/16883)! $++//'(9CD>4.$$ $%)*-//2693,.075-&)3792,$ ")-1347<>@G71(! **)&'*.0350+%(=A2'%)579<94( +/11! !%'),342)1?=0)" .1,$',-01)*).AG6-/048:< /2583$%+66/% %)++*),+&%06,%$# !/40')-/31$$,@HFC<6887:==@B7%! 6A235,% +,/13.%#"(16+ !#$(04-$&+,+$ %2>D6,59:989889=0 ,.22<=33* .22671# !!&/42& *1$&+,/3779733, $$PQ /004B6* !$$ $))'/3) %&$&.7;4 )2$)*3-)466/%$ !),02+' %$5)%*+%$! (+'0:==4 $+,,1643"%)" !)/1)*+ +7=-%%&$! !3)3=. %&*/3113 !$$PQ ',4-%)/) ,6/%$$" +(!<- %),0354- .13-&,-* 14'$$! %))&%$! '3*$$" !&$%3 &%"%& 9836' )&#%%! $*)++" .-/:% !"&)()15, )" /.-+)! //6B& #'*,.42$ $/,-*% IF1A1 "%.2/-*#! $/.,*($!#$"%PQ #57-*'$#"$&' ..//.-,)'(.212PQ ",,)&%'.;<6/+',,)%! '//,+//*)+.4:=>PQ $(&(),5?@:2/,,''*$ -!,,%.0%)./7 #43((+9CA=3+,)+" &*)2!$96;;48@??PQ )/01%$ #3/').:@<3)$&)! /)4$%)8=A@?><@PQ !.0/.+//./1//* *.').3784/% ,,#%()25:<99=PQ %10// 0 /+134,.25653." )++-! # %0,*,384'%PQ 42//11/&(/563135650( (./36$ !"23.,27- 6:=<)&931-13-!$.69433563+ ,/258 #$,96-37)$!PQ 38;?B>;63/.22.-068934673( ,638<6$ *),/6."')==138*$)PQ 35:=@B>953-/1.-368<:8995& %668:9( )$'*.:&$*==8/, -19=@CA>:83+2.,0157: !""/88$ !)*# 6/0%&' !$*38,.<;60" +07=@CD=6>@.*)&(*-03;@@<- 6.3/% #/23989=2,*% /039>B@ "9E7,)+/3667:?CE/!" $$%199207/ 9K8@) 3933" !0042381%$(.-)56PQ 556:=@@ 5C958=BGGA96;='"+- !!%.94.6BDCFM='(204967& //2346% $59232$PQ :9<@?@C% 6D;;CJLONG952 (9304=FCDDE>% $,585' !.//11'$/;81$ 9:CE><D3,5G@@HF>IF94) $#%+*159C=:>FG) *31*# $/51# 89C=.!:9=C<9AFGCA7&( /%3%!'+5A<6=C>$ -672.3<<961.%! ,,%=<9/69/02. "773//33/,+) /1$'9< 069850(*)'% %/+$ !&##34 %0<PQ %"$:C9.*$ !+6@PQ "$$6CD>>5 !##() ".;CPQ %'0>GFA:378+&&%$$,& ,:CPQ $(,027CGG@6681//,)%$/ '7CPQ !%*/1,/44CC;6547@=2*!%.$ %;CPQ '$)=3 #%)*())3DLHB ?MB9/% ! "'6?6$ *;=PQ $%&,9D6 !$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ !)/38;@( "$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ +/0,$%&%%,26:5) "$%&(/7;<=BGIJIGMG=953'%(1<<63/! $*.8PQ 876=@?<3),3:8$ !&((),3=;::=EHIC:<F3)'""#&+/,', #&(0PQ FC8:CF@7/08<( "'()*, 169?:6=C=2..3'" "%&)PQ HD99=A@9534/ !26(%5, ! !),''*-16<@=430/,+/)! ??979>@@:-! !$+%-*),/37<@:2/-*)+*" 4?=95;@@9& *#%.,/136884/,)'),,%)+(%$$ />C:13?@9)$ !!89+ !)$%*-/13321/,*3*)-/0/+&$$! 6A:0,8B=1+)/68.%/(,9=2% ")$"%)-02331/31)/().241+%##! *79/)/:<651/33)2<8.6=9. !$%,56643/75,'&).340+&#!$$%#! .5.)/46682%#$$-973:=<7) !$'+4:964063+( ,33/+(&'),*)'# "%%.2379:1&"%(&.36@?@D5 !$%')/8:86>=2)&!!-231 34772+* &46339C@4+,3/)/:<D/8J=' "%'))+336@3(/)%#%,34569<=?CE5,)! #'21.7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,& #,0258<?ADGE2 "'(# "%),,/6983$ &4<9+4DD>?J>/*-6;<6,,/25.))3,' ",.0369;=AGE. !%%(,.040' 2A?EA4*+/683*.493/($!/-, 0246689:AC7% $%##(.23& :96,#"%)*(%(364, M4%"!!"560&)/<9;989;>3$ "03., PQ UUUUUU wwwwww UUUUUU wwwwww 44444 CCCCC 44444 CCCCC $42" RRPTH !NAME FPTHARDaffy:Desktop Folder:Franz Project:FM Pro Solution:3-More Changes:Activity Log.FP3 MSPCA NAMEA Activity Log.FP3 RPTHA!::3-More Changes:Activity Log.FP3 ORPTH FPTHAODaffy:Desktop Folder:Franz Project:FM Pro Solution:3-More Changes:Main Menu.FP3 MSPCA NAMEA Main Menu.FP3 RPTHA Main Menu.FP3 4RPTH FPTHA4Daffy:Desktop Folder:3-More Changes:Activity Log.FP3 MSPCA NAMEA Activity Log.FP3 ORPTH FPTHAODaffy:Desktop Folder:Franz Project:FM Pro Solution:5-More Changes:Main Menu.FP3 MSPCA NAMEA Main Menu.FP3 RPTHA Main Menu.FP3 0RPTH FPTHA0Daffy:Desktop Folder:7-More Changes:Invoices.FP3 MSPCA NAMEA Invoices.FP3 RPTHA Invoices.FP3 )NAME FPTHA)Daffy:Desktop Folder:x40:FAT:Invoices.FP3 MSPCA NAMEA Invoices.FP3 /NAME FPTHA/Daffy:FileMaker Pro 3.0 folder:Activity Log.FP3 MSPCA NAMEA Activity Log.FP3 NAMEA Activity Log.FP3 ZONEA (LIST LISTA RPTHA Activity Log.FP3 (LIST LISTA Busines Personal Vendor VDEFA( (LIST LISTA Medium VDEFA( (LIST LISTA Mobile School VDEFA( (LIST LISTA Letter VDEFA( (LIST LISTA Closed VDEFA( (LIST LISTA 9 to 5 After 5 Anytime VDEFA( (LIST LISTA<First Name Last Name Company Name Zip Code Custom Sort Order VDEFA( Personal Title ValuesB Contact Type Values VDEFA( FMRLA FMRLA FMRLA FMRLA FMRLA Phone NumbersC Activity LogD Show ActionE Main MenuF Invoices Priority ValuesD Phone Number ValuesE Action Type ValuesF Action Status ValuesG Hour ValuesH Sort Order SRPTH "NAME FPTHASDaffy:Desktop Folder:Franz Project:FM Pro Solution:3-More Changes:Phone Numbers.FP3 MSPCA NAMEA Phone Numbers.FP3 RPTHA"::3-More Changes:Phone Numbers.FP3 RRPTH !NAME FPTHARDaffy:Desktop Folder:Franz Project:FM Pro Solution:3-More Changes:Activity Log.FP3 MSPCA NAMEA Activity Log.FP3 RPTHA!::3-More Changes:Activity Log.FP3 ORPTH FPTHAODaffy:Desktop Folder:Franz Project:FM Pro Solution:3-More Changes:Main Menu.FP3 MSPCA NAMEA Main Menu.FP3 RPTHA Main Menu.FP3 4RPTH FPTHA4Daffy:Desktop Folder:3-More Changes:Activity Log.FP3 MSPCA NAMEA Activity Log.FP3FP3 Phone Number Location Hours 10X Cancelled 15X Cancelled Pro 3.0F! Pro 3.0M% Sunday Monday Tuesday Wednesday Thursday Friday Saturday January February March April August September October November December 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter